Showing posts with label odbc. Show all posts
Showing posts with label odbc. Show all posts

Monday, March 26, 2012

Need function for padding

Hi

I am using Format function in my query when I was using access tables.

Now I have imported my tables in Sql server and linked through odbc. Now in my query it throws message for "Format" function. I tried for Replicate function but still not able to get this problem.

Same case for Date and chr.you need to use convert or cast, not format.|||it sounds like you are doing SQL Passthrough in jet against sql server, and now you need to use SQL Server syntax instead of jet/access sql.'

cheers|||Originally posted by eisoffind
Hi

I am using Format function in my query when I was using access tables.

Now I have imported my tables in Sql server and linked through odbc. Now in my query it throws message for "Format" function. I tried for Replicate function but still not able to get this problem.

Same case for Date and chr.

If i understand your question correctly, you want to be able to pad the left of a number with another value. For example '555' --> '000555'

Attached are two SQL2K UDFs to lpad and rpad.sql

Monday, March 19, 2012

need an DB2 ODBC

I have been searching all over and I cannot find or locate a DB2 odbc. We
setup SQL 2000 on a windows 2003 server that needs to pull data from an
iSeries AS400 using DB2. WE CANNOT LOCATE THE ODBC! Please, ANYONE who
can give us directon on where to get the driver, would be appreciated. We'v
e
located so many pages, but none have the actual download.
Can anyone help? All I need is that ODBC connection.
Thankshttp://www.microsoft.com/downloads/...&DisplayLang=en
"sunburst01" <sunburst01@.discussions.microsoft.com> a crit dans le message
de news: 320BD888-2643-42D0-9BAC-89D6BA47056C@.microsoft.com...
>I have been searching all over and I cannot find or locate a DB2 odbc. We
> setup SQL 2000 on a windows 2003 server that needs to pull data from an
> iSeries AS400 using DB2. WE CANNOT LOCATE THE ODBC! Please, ANYONE who
> can give us directon on where to get the driver, would be appreciated.
> We've
> located so many pages, but none have the actual download.
> Can anyone help? All I need is that ODBC connection.
> Thanks|||Thanks Christian, but I tried that one, its for SQL 2005...we're running SQ
L
2000. It wouldn't install on 2k...
There has to be one out there, I've search IBM site, (no luck, I can't find
ANY downloads there), and I've tried MS site as well.
But thank you anyway
"Christian Hamel" wrote:

> http://www.microsoft.com/downloads/...&DisplayLang=en
>
> "sunburst01" <sunburst01@.discussions.microsoft.com> a écrit dans le messa
ge
> de news: 320BD888-2643-42D0-9BAC-89D6BA47056C@.microsoft.com...
>
>|||[url]http://www-306.ibm.com/software/data/db2/udb/support/downloadv8_windows32bit.html[
/url]
This page has the links to the DB2 client and the new fixpack 12 that
came out yesterday. It's not much fun configuring it, but neither is
DB2.|||Oops, sorry, I read too fast..
I use to extract a bunch of information from our AS/400 (DB2) on our SQL
Server 2000 Enterprise edition using DTS. To do so, I've installed Client
Access Express on my server and defined an ODBC to my AS/400. It works very
well. Are you using Client Access in your company?
I remember @. that time, I've tried many things and nothing worked except
Client Access
"sunburst01" <sunburst01@.discussions.microsoft.com> a crit dans le message
de news: 82192B6C-DE2E-4347-8EC8-9DA2306D502D@.microsoft.com...[vbcol=seagreen]
> Thanks Christian, but I tried that one, its for SQL 2005...we're running
> SQL
> 2000. It wouldn't install on 2k...
> There has to be one out there, I've search IBM site, (no luck, I can't
> find
> ANY downloads there), and I've tried MS site as well.
> But thank you anyway
>
> "Christian Hamel" wrote:
>

need an DB2 ODBC

I have been searching all over and I cannot find or locate a DB2 odbc. We
setup SQL 2000 on a windows 2003 server that needs to pull data from an
iSeries AS400 using DB2. WE CANNOT LOCATE THE ODBC! Please, ANYONE who
can give us directon on where to get the driver, would be appreciated. We've
located so many pages, but none have the actual download.
Can anyone help? All I need is that ODBC connection.
Thankshttp://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en
"sunburst01" <sunburst01@.discussions.microsoft.com> a écrit dans le message
de news: 320BD888-2643-42D0-9BAC-89D6BA47056C@.microsoft.com...
>I have been searching all over and I cannot find or locate a DB2 odbc. We
> setup SQL 2000 on a windows 2003 server that needs to pull data from an
> iSeries AS400 using DB2. WE CANNOT LOCATE THE ODBC! Please, ANYONE who
> can give us directon on where to get the driver, would be appreciated.
> We've
> located so many pages, but none have the actual download.
> Can anyone help? All I need is that ODBC connection.
> Thanks|||Thanks Christian, but I tried that one, its for SQL 2005...we're running SQL
2000. It wouldn't install on 2k...
There has to be one out there, I've search IBM site, (no luck, I can't find
ANY downloads there), and I've tried MS site as well.
But thank you anyway :)
"Christian Hamel" wrote:
> http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en
>
> "sunburst01" <sunburst01@.discussions.microsoft.com> a écrit dans le message
> de news: 320BD888-2643-42D0-9BAC-89D6BA47056C@.microsoft.com...
> >I have been searching all over and I cannot find or locate a DB2 odbc. We
> > setup SQL 2000 on a windows 2003 server that needs to pull data from an
> > iSeries AS400 using DB2. WE CANNOT LOCATE THE ODBC! Please, ANYONE who
> > can give us directon on where to get the driver, would be appreciated.
> > We've
> > located so many pages, but none have the actual download.
> >
> > Can anyone help? All I need is that ODBC connection.
> >
> > Thanks
>
>|||http://www-306.ibm.com/software/data/db2/udb/support/downloadv8_windows32bit.html
This page has the links to the DB2 client and the new fixpack 12 that
came out yesterday. It's not much fun configuring it, but neither is
DB2.|||Oops, sorry, I read too fast..
I use to extract a bunch of information from our AS/400 (DB2) on our SQL
Server 2000 Enterprise edition using DTS. To do so, I've installed Client
Access Express on my server and defined an ODBC to my AS/400. It works very
well. Are you using Client Access in your company?
I remember @. that time, I've tried many things and nothing worked except
Client Access :(
"sunburst01" <sunburst01@.discussions.microsoft.com> a écrit dans le message
de news: 82192B6C-DE2E-4347-8EC8-9DA2306D502D@.microsoft.com...
> Thanks Christian, but I tried that one, its for SQL 2005...we're running
> SQL
> 2000. It wouldn't install on 2k...
> There has to be one out there, I've search IBM site, (no luck, I can't
> find
> ANY downloads there), and I've tried MS site as well.
> But thank you anyway :)
>
> "Christian Hamel" wrote:
>> http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en
>>
>> "sunburst01" <sunburst01@.discussions.microsoft.com> a écrit dans le
>> message
>> de news: 320BD888-2643-42D0-9BAC-89D6BA47056C@.microsoft.com...
>> >I have been searching all over and I cannot find or locate a DB2 odbc.
>> >We
>> > setup SQL 2000 on a windows 2003 server that needs to pull data from an
>> > iSeries AS400 using DB2. WE CANNOT LOCATE THE ODBC! Please, ANYONE
>> > who
>> > can give us directon on where to get the driver, would be appreciated.
>> > We've
>> > located so many pages, but none have the actual download.
>> >
>> > Can anyone help? All I need is that ODBC connection.
>> >
>> > Thanks
>>