I am getting the following error while try to read a recordset:
"ODBC driver does not support the requested properties."
I am running vb6 code on Windows 7 with SQL 2008.
This code has run fine in XP and SQL 2005 and there are literally 100's of similar statements in the project (many using the same connection) which work just fine. The pertinent lines are:
When the project is opened, the following are declared (the gdb.version is 6.1):
Dim gDB As ADODB.Connection
Dim gDBCmd As New ADODB.Command
Set gDB = New ADODB.Connection
gDB.Open “DSN=<Sql DSN Data Source>;UID=sa;PWD=<Password>”
Set gDBCmd.ActiveConnection = gDB
This is the procedure where the error occurs:
Dim rsStore As New ADODB.Recordset
gDBCmd.CommandText = “Select <FieldName1> From <TableName> Where <FieldName2> = 1”
Set rsStore = gDBCmd.Execute <-- error occurs
Try to replace the Early Binding to Late Binding
Dim gDB As Object 'ADODB.Connection
Dim gDBCmd As Object 'New ADODB.Command
Set gDB = CreateObject("ADODB.Connection")
Set gDBCmd = CreateObject("ADODB.Command")
If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.
If you get continual lockouts after changing your Active Directory password, there are several possible reasons. Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
By default the complete memory dump option is disabled in windows . If we want to enable the complete memory dump for a diagnostic purpose, we have a solution for it. here we are using the registry method to enable this.
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply.
This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.
The viewer will learn how to use the return statement in functions in C++. The video will also teach the user how to pass data to a function and have the function return data back for further processing.