Odbc trace

Hi

I run odbc trace , thru ODBC Adliministrator > Tracing tab.

Is there a way to have the trace of

sql_parm_input, sql_c_wchar, sql_varchar of sqlbindparameter

For exmple :

MSACCESS 698-548 ENTER SQLBindParameter
HSTMT 07CD24F8
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 36
SWORD 0
PTR 0x67184BD4
SQLLEN 0
SQLLEN * 0x67184BD0

Thanks

Seems that odbcspy is doing the job ,

Found that odbcspy come with mdac sdk 2.0, but cannot find it

does anybody where can I download IT ?

|||

You can get the latest MDAC SDK from:

http://www.microsoft.com/downloads/details.aspx?familyid=5067faf8-0db4-429a-b502-de4329c8c850&displaylang=en

You could also search the http://www.microsoft.com website for "MDAC SDK".

ODBC Text Driver Issue for Tab delimited File

I am trying to do a ODBC Connection to a Tab delimited file. However it is
not parsing the tabs. Any advice?
Thanks
Here is my connection string:
Private ConnectionString As String = "Driver={Microsoft Text Driver (*.txt;
*.csv)};DRIVERID=27;Fil=Text;Format=TABDELIMITED;" & _
"COLNAMEHEADER=TRUE;DefaultDir=" & _
Application.StartupPath
And my calls to query the file:
Dim Adapter As New OdbcDataAdapter("SELECT * FROM Test.csv", Con)
When you use the Text Driver, the format is determined by
the schema.ini file. The format statement goes in the
schema.ini file. That's how I remember it anyway.
The following link has more information on the drive and a
link to information on the schema.ini file - watch out for
line wrap on the link:
http://msdn.microsoft.com/library/de..._details. asp
-Sue
On Tue, 1 Feb 2005 06:55:04 -0800, "Neil"
<Neil@.discussions.microsoft.com> wrote:

>I am trying to do a ODBC Connection to a Tab delimited file. However it is
>not parsing the tabs. Any advice?
>Thanks
>Here is my connection string:
> Private ConnectionString As String = "Driver={Microsoft Text Driver (*.txt;
>*.csv)};DRIVERID=27;Fil=Text;Format=TABDELIMITED; " & _
> "COLNAMEHEADER=TRUE;DefaultDir=" & _
> Application.StartupPath
>And my calls to query the file:
> Dim Adapter As New OdbcDataAdapter("SELECT * FROM Test.csv", Con)
>
>
|||Thanks Sue. That was the solution.
Neil
"Sue Hoegemeier" wrote:

> When you use the Text Driver, the format is determined by
> the schema.ini file. The format statement goes in the
> schema.ini file. That's how I remember it anyway.
> The following link has more information on the drive and a
> link to information on the schema.ini file - watch out for
> line wrap on the link:
> http://msdn.microsoft.com/library/de..._details. asp
> -Sue
> On Tue, 1 Feb 2005 06:55:04 -0800, "Neil"
> <Neil@.discussions.microsoft.com> wrote:
>
>

ODBC Text Driver Issue for Tab delimited File

I am trying to do a ODBC Connection to a Tab delimited file. However it is
not parsing the tabs. Any advice?
Thanks
Here is my connection string:
Private ConnectionString As String = "Driver={Microsoft Text Driver (*.
txt;
*. csv)};DRIVERID=27;Fil=Text;Format=TABDEL
IMITED;" & _
"COLNAMEHEADER=TRUE;DefaultDir=" & _
Application.StartupPath
And my calls to query the file:
Dim Adapter As New OdbcDataAdapter("SELECT * FROM Test.csv", Con)When you use the Text Driver, the format is determined by
the schema.ini file. The format statement goes in the
schema.ini file. That's how I remember it anyway.
The following link has more information on the drive and a
link to information on the schema.ini file - watch out for
line wrap on the link:
http://msdn.microsoft.com/library/d...ail
s.asp
-Sue
On Tue, 1 Feb 2005 06:55:04 -0800, "Neil"
<Neil@.discussions.microsoft.com> wrote:

>I am trying to do a ODBC Connection to a Tab delimited file. However it is
>not parsing the tabs. Any advice?
>Thanks
>Here is my connection string:
> Private ConnectionString As String = "Driver={Microsoft Text Driver (
*.txt;
>*. csv)};DRIVERID=27;Fil=Text;Format=TABDEL
IMITED;" & _
> "COLNAMEHEADER=TRUE;DefaultDir=" & _
> Application.StartupPath
>And my calls to query the file:
> Dim Adapter As New OdbcDataAdapter("SELECT * FROM Test.csv", Con)
>
>|||Thanks Sue. That was the solution.
Neil
"Sue Hoegemeier" wrote:

> When you use the Text Driver, the format is determined by
> the schema.ini file. The format statement goes in the
> schema.ini file. That's how I remember it anyway.
> The following link has more information on the drive and a
> link to information on the schema.ini file - watch out for
> line wrap on the link:
> http://msdn.microsoft.com/library/d...a
ils.asp
> -Sue
> On Tue, 1 Feb 2005 06:55:04 -0800, "Neil"
> <Neil@.discussions.microsoft.com> wrote:
>
>

ODBC Invalid DNS Error

I try and remove an entry from ODBC administrator, USER
DSN tab, and i get the error, INVALID DSN.
how can i remove this entry?I had this same problem and after a little searching found a fix at e.ms/archive86-2004-3-446049.html" target="_blank">http://www.mcs
e.ms/archive86-2004-3-446049.html
Here it is:
ODBC entries are controlled in the registry. I would suggest using
regedt32 or regedit (if you are on Win 20003/XP), and go to
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC and try adding full control permissions
for the affected user/groups, replacing the values in the subkeys. Good
luck.
Andy S.
2004-03-04, 12:24 pm
It took a little bit of fighting in my case to get it to take, but when it d
id I logged out then back in and it worked like a charm.
-Nick